Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
RFP Investment Reporting and Analytics Software - Q&A's
ta Qwkra CALIFORNIA INVESTMENT REPORTING AND ANALYTICS SOFTWARE RFP QUESTIONS AND ANSWERS Q1: Under Scope of Services, Subsection (b), you state the need for "Portfolio Total Return and Portfolio Total Earnings." We realize sometimes there is terminology used that may be by mistake, so we want to clarify whether or not "Total Return" (which includes interest, amortization, book gains & losses AND realized gains & losses from actual transactions) is what you are looking for. Answer: The City will be looking at each system's capability regarding the types of yield or return numbers reports. In any response, please just note the types of return or earnings numbers reported and how they are calculated. Q2: Under Scope of Services, Subsection (e), you asked for the ability to import from your custodial bank information like market pricing and interest received. We want to clarify that this is a feature that we purposely have avoided after reports of erroneous data being transmitted by custodians into competitor systems that caused headaches and manual workarounds after they were discovered with no resolution was possible. When utilizing custodial data feeds, you are put into a "day -ahead" environment where the previous days' activity is registered and available only on the next business day. Answer: The City will review all responses for either import capabilities or real-time market data, and weigh this information accordingly when making our final decision. Our biggest concern would be that any reporting generated for month-end, particularly market prices, will tie back to the statement from our custodial bank. Q3: Under Scope of Services, Describe the Software, Subsection (e), our system does provide journal accounting functionality and ERP connectivity for institutions needing customized data feeds. We need to clarify whether you need customized data formatted and exported to an external ERP platform used by the city, or if general journal entry and accounting reports are all that is needed. Answer: The City does not currently export reporting to our ERP but would like to know what functionality is out there. Please provide your system's capabilities and note costs accordingly. Q4: What is the total market value (AUM) of your portfolio? Could you provide recent holdings report or share the % of portfolio breakout of the security types (US Treasuries, Federal Agencies, Corporate Bonds, CDs, etc.) You mentioned you invest in both LAIF and CAMP, what is the total market value for each one? Answer: See chart below, as of Feb 29, 2024. ta Qwkra CALIFORNIA Investments Par Value Market Value gook Value % of Porifoio Term 17ays to Maturity YTM 365 Equiv. Bank As its 0,062,744.13 5,362,744.13 8,362,744.13 3.16 1 - C.000 CAMP7ERM 26,000,000.00 20,000,000.00 20,000,600.06 7.86 293 42 5.645 Local Agency Investment Fund -City 19,969,746.01 16,969,634.51 19,969,740.01 7.75 1 1 3.929 Local Agency lnvstmnt Fund -Housing 2,165,968.10 2,674,195.06 2,105,608.10 6.83 1 1 3.929 Ma ney Mark.Mutual Funds 14,850,89425 14,850,89425 14,B50,894.25 5.85 1 1 5.180 Mo ney Market A -is - CAMP 36,273,452-67 36,273,452.67 36;273,452.67 11.93 1 1 5.540 Federal Agency Coupon Securities 56,500,060.06 58,295,071.06 56,202,246.58 22.97 1,554 696 2.969 Treasury Coupon Securities 44,500,060.00 42,736,647.50 43,571,669.38 17.16 1,315 604 3.181 Treasury ❑isCUrint Notes 7,606,060.60 5,918,590.06 B�B34.628.38 2.59 164 80 5.451 Certificate of Deposits 41,655,660.00 46,513,431.50 41,654,377.56 19.16 1,628 M2 3.642 Corporate Notes 1,506,060.60 1,423,795.00 1,470,410.06 6.56 1,827 1,290 3.654 Man" Market with Fiscal Agent 14,616.16 14,616.10 14,616.16 6.01 1 1 6.600 CER67 - OPEB Trust 1,955,699.21 1,955,699.21 1.955.D99.21 6.77 1 1 6.600 PARS Fe mn Trust 5,544,348.61 5,544,348.61 5,544,348.61 2.19 1 1 0.000 255.030,903.28 249,630,659.74 253,667,975.12 100.00% 882 495 3.563 Q5: What is the number of distinct securities (If you can provide a holdings report, that would give us the answer as well)? Answer: Treasuries 52, Agencies 69, CDs 166, Corporates 2. Q6: You mention you work with 1 custodian bank; how many accounts are at that custody? Answer: One (1) Q7: What is the ERP system you use for your general ledger? Answer: We use Tyler Technologies ERP Pro 10 Q8: Your question - "(d) If cloud-based/hosted, please list how many times over the past two years the system was unavailable to clients. Describe the back-up system in place, including disaster recovery or business continuity plans. Describe all security measures and disclose any hosting partners if applicable." — to be able to share some of the supporting documentation, we are required to have an NDA in place. Would the City of La Quinta be willing to sign an NDA? If not, we will still provide as much information as possible without one in place. Answer: Please provide as much information as possible that would not require the NDA. Q9: What is your budget for this RFP: Answer: It is not our normal practice to specify budgets for RFPs. Q10- Who is your current provider and when does the contract expire? Answer: We currently use Emphasys Sympro and renew annually. ta Qwkra CALIFORNIA - Q11: Is General Ledger functionality required? Answer: General Ledger functionality is not required, but please provide any capabilities you can provide such as generation of reporting to make entries and/or exports that can be utilized for journal entries. Q12: How many investment portfolios are there? Answer: One (1) Q13: How many user licenses are required: Answer: Three (3) Q14: Who is your current custodian? Answer: US Bank Q15: Is this a request for a full investment accounting solution or a reporting only solution? Answer: Currently we use it for reporting. Please provide your system's capabilities regarding other functions. For anyone needing the full portfolio, please see attached as of December 31, 2023, the most recent published copy. , �QaLtr6 GEM of'the DESERT — City of La Quinta Portfolio Management Portfolio Summary December 31, 2023 City of La Quinta Investments Total Earnings December 31 Month Ending Fiscal Year To Date Current Year 653,005.71 3,947,056.43 Average Daily Balance 229,230,087.47 238,693,418.97 Effective Rate of Return 3.35% 3.28% 1 certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued by our financial institutions to determine the fair market value of investments at month end. Claudia Martinez, Finance Director/City Treasurer Reporting period 12/01/2023-12/31/2023 Run Date: 02/01/2024 - 18:22 Portfolio CITY CP PM (PRF—PMI) 7.3.0 Report Ver. 7.3.6.1 Par Market Book % of Days to YTM Investments Value Value Value Portfolio Term Maturity 365 Equiv. Bank Accounts 8,062,744.13 8,062,744.13 8,062,744.13 3.53 1 1 0.000 CAMP TERM 20,000,000.00 20,000,000.00 20,000,000.00 8.76 263 102 5.645 Local Agency Investment Fund -City 14,507,754.14 13,990,936.78 14,507,754.14 6.35 1 1 3.929 Local Agency Invstmnt Fund -Housing 2,084,665.23 2,053,564.57 2,084,665.23 0.91 1 1 3.929 Money Market Accounts - CAMP 30,132,190.61 30,132,190.61 30,132,190.61 13.19 1 1 5.550 Federal Agency Coupon Securities 52,000,000.00 50,037,016.00 51,755,823.74 22.66 1,524 798 2.358 Federal Agency Discount 2,000,000.00 1,951,080.00 1,916,929.44 0.84 287 171 5.533 Treasury Coupon Securities 45,500,000.00 44,027,795.00 44,557,338.79 19.51 1,202 720 3.242 Treasury Discount Notes 5,000,000.00 4,910,030.00 4,869,608.38 2.13 180 128 5.504 Certificate of Deposits 41,546,000.00 40,174,158.18 41,545,377.50 18.19 1,642 891 2.999 Corporate Notes 1,500,000.00 1,448,300.00 1,470,410.00 0.64 1,827 1,350 3.054 Money Market with Fiscal Agent 13,958.98 13,958.98 13,958.98 0.01 1 1 0.000 CERBT - OPEB Trust 1,955,099.21 1,955,099.21 1,955,099.21 0.86 1 1 0.000 PARS Pension Trust 5,544,348.61 5,544,348.61 5,544,348.61 2.43 1 1 0.000 229,846,760.91 224,301,222.07 228,416,248.76 100.00% 920 505 3.407 Investments Total Earnings December 31 Month Ending Fiscal Year To Date Current Year 653,005.71 3,947,056.43 Average Daily Balance 229,230,087.47 238,693,418.97 Effective Rate of Return 3.35% 3.28% 1 certify that this report accurately reflects all pooled investments and is in compliance with the California Government Code and the City Investment Policy. As Treasurer of the City of La Quinta, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months. The City of La Quinta used the monthly account statements issued by our financial institutions to determine the fair market value of investments at month end. Claudia Martinez, Finance Director/City Treasurer Reporting period 12/01/2023-12/31/2023 Run Date: 02/01/2024 - 18:22 Portfolio CITY CP PM (PRF—PMI) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Report Ver. 7.3.6.1 Portfolio Management Page 1 Portfolio Details - Investments December 31, 2023 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Bank Accounts SYS1293 1293 Bank of New York 09/01/2020 1,319,319.64 1,319,319.64 1,319,319.64 1 1 0.000 059731851 1228 BMO f/k/a Bank of the West 08/20/2019 5,699,749.19 5,699,749.19 5,699,749.19 1 1 0.000 SYS1059 1059 City Petty Cash 07/01/2016 3,300.00 3,300.00 3,300.00 1 1 0.000 SYS1318 1318 Dune Palms Mobile Estates 03/09/2021 896,553.20 896,553.20 896,553.20 1 1 0.000 SYS1062 1062 La Quinta Palms Realty 07/01/2016 143,822.10 143,822.10 143,822.10 1 1 0.000 Subtotal and Average 9,092,321.78 8,062,744.13 8,062,744.13 8,062,744.13 1 1 0.000 CAMP TERM 6067-001TERM 1521 California Asset Management Pr 07/24/2023 20,000,000.00 20,000,000.00 20,000,000.00 5.645 263 102 5.645 04/12/2024 Subtotal and Average 20,000,000.00 20,000,000.00 20,000,000.00 20,000,000.00 263 102 5.645 Local Agency Investment Fund -City 98-33-434 1055 Local Agency Inv Fund 14,507,754.14 13,990,936.78 14,507,754.14 3.929 1 1 3.929 Subtotal and Average 14,507,754.14 14,507,754.14 13,990,936.78 14,507,754.14 1 1 3.929 Local Agency Invstmnt Fund -Housing 25-33-005 1113 Local Agency Inv Fund 2,084,665.23 2,053,564.57 2,084,665.23 3.929 1 1 3.929 Subtotal and Average 2,084,665.23 2,084,665.23 2,053,564.57 2,084,665.23 1 1 3.929 Money Market Accounts - CAMP SYS1153 1153 California Asset Management Pr 09/26/2018 30,132,190.61 30,132,190.61 30,132,190.61 5.550 1 1 5.550 Subtotal and Average 29,995,331.00 30,132,190.61 30,132,190.61 30,132,190.61 1 1 5.550 Federal Agency Coupon Securities 3133EKWV4 1212 Federal Farm Credit Bank 08/02/2019 500,000.00 491,025.00 499,500.00 1.850 1,820 207 1.871 07/26/2024 3133EKP75 1224 Federal Farm Credit Bank 09/17/2019 500,000.00 488,475.00 498,750.00 1.600 1,827 260 1.652 09/17/2024 3133ELEA8 1242 Federal Farm Credit Bank 12/17/2019 1,000,000.00 978,560.00 998,600.00 1.700 1,736 260 1.731 09/17/2024 3133ELNEO 1246 Federal Farm Credit Bank 02/14/2020 1,000,000.00 995,250.00 999,000.00 1.430 1,461 44 1.456 02/14/2024 3133ELH23 1280 Federal Farm Credit Bank 06/09/2020 500,000.00 472,580.00 499,850.00 0.500 1,826 525 0.506 06/09/2025 3133ELH80 1282 Federal Farm Credit Bank 06/10/2020 500,000.00 472,600.00 500,000.00 0.680 1,826 526 0.680 06/10/2025 3133EM2C5 1330 Federal Farm Credit Bank 08/10/2021 500,000.00 455,765.00 498,000.00 0.710 1,826 952 0.792 08/10/2026 3133EM4X7 1338 Federal Farm Credit Bank 09/28/2021 1,000,000.00 916,280.00 991,080.00 0.800 1,808 983 0.985 09/10/2026 3133ENCQ1 1344 Federal Farm Credit Bank 11/02/2021 1,000,000.00 918,560.00 1,000,000.00 1.270 1,826 1,036 1.270 11/02/2026 3133ENGN4 1355 Federal Farm Credit Bank 12/09/2021 1,000,000.00 963,720.00 1,000,000.00 0.970 1,096 343 0.970 12/09/2024 3133ENYH7 1401 Federal Farm Credit Bank 06/10/2022 500,000.00 494,280.00 499,080.00 2.625 731 161 2.720 06/10/2024 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 2 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate Days to Term Maturity YTM Maturity 365 Date Federal Agency Coupon Securities 3133ENL99 1426 Federal Farm Credit Bank 09/15/2022 1,000,000.00 976,330.00 997,492.55 3.375 1,826 1,353 3.430 09/15/2027 3133ENQ29 1433 Federal Farm Credit Bank 09/30/2022 1,000,000.00 999,120.00 996,400.00 4.000 1,825 1,367 4.080 09/29/2027 3133EN31-11 1441 Federal Farm Credit Bank 11/29/2022 1,000,000.00 999,360.00 998,650.00 4.000 1,826 1,428 4.030 11/29/2027 3133EN3S7 1446 Federal Farm Credit Bank 12/07/2022 1,000,000.00 990,410.00 998,000.00 3.750 1,826 1,436 3.794 12/07/2027 3133EPAV7 1464 Federal Farm Credit Bank 02/15/2023 1,000,000.00 994,810.00 995,400.00 3.875 1,825 1,505 3.977 02/14/2028 3133EPME2 1505 Federal Farm Credit Bank 06/08/2023 1,000,000.00 994,790.00 998,190.00 3.875 1,827 1,620 3.915 06/08/2028 3133EPQDO 1527 Federal Farm Credit Bank 07/31/2023 1,000,000.00 1,009,840.00 998,655.69 4.250 1,813 1,659 4.280 07/17/2028 3133EPSK2 1531 Federal Farm Credit Bank 08/18/2023 1,000,000.00 1,009,810.00 990,400.00 4.250 1,816 1,680 4.467 08/07/2028 3133EPC45 1554 Federal Farm Credit Bank 11/13/2023 1,000,000.00 1,031,690.00 999,770.00 4.625 1,827 1,778 4.630 11/13/2028 3130AFW94 1177 Federal Home Loan Bank 03/01/2019 500,000.00 498,310.00 498,550.00 2.500 1,810 43 2.563 02/13/2024 3130AJKW8 1281 Federal Home Loan Bank 06/03/2020 500,000.00 472,580.00 499,850.00 0.500 1,836 529 0.506 06/13/2025 3130AJRP6 1283 Federal Home Loan Bank 06/30/2020 300,000.00 284,013.00 300,000.00 0.680 1,826 546 0.680 06/30/2025 3130AKFA9 1298 Federal Home Loan Bank 12/07/2020 500,000.00 462,975.00 497,400.00 0.375 1,831 711 0.480 12/12/2025 3130AKMZ6 1302 Federal Home Loan Bank 01/14/2021 500,000.00 463,100.00 500,000.00 0.510 1,826 744 0.510 01/14/2026 313OAKN28 1304 Federal Home Loan Bank 01/29/2021 500,000.00 462,765.00 500,000.00 0.550 1,826 759 0.550 01/29/2026 3130ALV92 1312 Federal Home Loan Bank 03/30/2021 500,000.00 466,935.00 500,000.00 1.050 1,826 819 0.938 03/30/2026 3130AMFS6 1324 Federal Home Loan Bank 06/17/2021 1,000,000.00 921,290.00 993,420.00 0.750 1,821 893 0.885 06/12/2026 3130APBM6 1337 Federal Home Loan Bank 09/30/2021 1,000,000.00 914,330.00 999,000.00 1.000 1,826 1,003 1.021 09/30/2026 3130APB46 1339 Federal Home Loan Bank 10/13/2021 1,000,000.00 912,140.00 998,250.00 0.950 1,826 1,016 0.986 10/13/2026 3130APTV7 1347 Federal Home Loan Bank 11/24/2021 500,000.00 471,020.00 499,500.00 2.000 1,826 1,058 1.489 11/24/2026 3130AP2U8 1353 Federal Home Loan Bank 12/07/2021 1,000,000.00 962,740.00 987,100.00 0.550 1,127 372 0.976 01/07/2025 313OAQF65 1358 Federal Home Loan Bank 12/22/2021 1,000,000.00 919,680.00 999,750.00 1.250 1,825 1,085 1.255 12/21/2026 3130AQJR5 1364 Federal Home Loan Bank 01/27/2022 1,000,000.00 922,500.00 1,000,000.00 1.500 1,826 1,122 1.500 01/27/2027 3130AQSA2 1367 Federal Home Loan Bank 02/10/2022 1,000,000.00 930,940.00 1,000,000.00 1.830 1,826 1,136 1.830 02/10/2027 3130AQWY5 1374 Federal Home Loan Bank 02/25/2022 1,000,000.00 960,720.00 1,000,000.00 1.700 1,095 420 1.700 02/24/2025 3130ARGJ4 1385 Federal Home Loan Bank 04/14/2022 500,000.00 483,910.00 500,000.00 2.500 1,279 652 2.500 10/14/2025 3130ARGY1 1387 Federal Home Loan Bank 04/19/2022 1,000,000.00 955,040.00 1,000,000.00 2.700 1,826 1,204 2.700 04/19/2027 3130ASDV8 1409 Federal Home Loan Bank 06/28/2022 300,000.00 291,471.00 300,000.00 3.300 1,826 1,274 3.300 06/28/2027 3130ARHG9 1529 Federal Home Loan Bank 08/10/2023 1,000,000.00 995,160.00 982,520.00 2.125 202 58 5.391 02/28/2024 3130AXEL8 1541 Federal Home Loan Bank 10/03/2023 1,000,000.00 1,035,820.00 999,500.00 4.750 1,802 1,712 4.762 09/08/2028 3130AYBQ8 1566 Federal Home Loan Bank 12/29/2023 1,000,000.00 999,480.00 999,516.00 4.750 363 360 4.800 12/26/2024 3134GVYG7 1279 Federal Home Loan Mtg Corp 05/27/2020 1,000,000.00 946,870.00 1,000,000.00 0.625 1,826 512 0.625 05/27/2025 3137EAEU9 1297 Federal Home Loan Mtg Corp 12/07/2020 1,000,000.00 939,900.00 997,300.00 0.375 1,687 567 0.434 07/21/2025 3134GXGZ1 1301 Federal Home Loan Mtg Corp 12/30/2020 500,000.00 464,925.00 500,000.00 0.550 1,826 729 0.550 12/30/2025 3137EAEX3 1307 Federal Home Loan Mtg Corp 02/23/2021 500,000.00 466,760.00 495,999.50 0.375 1,673 631 0.552 09/23/2025 3137EAEX3 1310 Federal Home Loan Mtg Corp 03/30/2021 1,000,000.00 933,520.00 983,940.00 0.375 1,638 631 0.740 09/23/2025 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 3 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Federal Agency Coupon Securities 3134GW6C5 1359 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 453,480.00 486,000.00 0.800 1,757 1,031 1.403 10/28/2026 3137EAEU9 1361 Federal Home Loan Mtg Corp 01/05/2022 500,000.00 469,950.00 487,090.00 0.375 1,293 567 1.120 07/21/2025 3134GW5R3 1362 Federal Home Loan Mtg Corp 01/05/2022 400,000.00 373,132.00 391,360.00 0.650 1,391 665 1.232 10/27/2025 3134GWUQ7 1366 Federal Home Loan Mtg Corp 02/10/2022 1,000,000.00 898,660.00 945,570.00 0.700 1,784 1,094 1.870 12/30/2026 3134GYPJ5 1484 Federal Home Loan Mtg Corp 04/24/2023 1,000,000.00 992,340.00 999,100.00 5.200 1,820 1,568 5.220 04/17/2028 3135GOV75 1206 Federal National Mtg Assn 07/15/2019 500,000.00 491,660.00 495,950.00 1.750 1,814 183 1.922 07/02/2024 3135GO5S8 1288 Federal National Mtg Assn 08/14/2020 500,000.00 469,655.00 500,000.00 0.500 1,826 591 0.500 08/14/2025 3136G4N74 1289 Federal National Mtg Assn 08/21/2020 1,000,000.00 939,540.00 1,000,000.00 0.560 1,826 598 0.560 08/21/2025 3136G4M75 1290 Federal National Mtg Assn 08/28/2020 500,000.00 469,490.00 499,750.00 0.520 1,816 595 0.530 08/18/2025 3135GO6E8 1291 Federal National Mtg Assn 11/18/2020 500,000.00 480,680.00 499,250.00 0.420 1,461 322 0.458 11/18/2024 3135GA2Z3 1292 Federal National Mtg Assn 11/17/2020 500,000.00 464,535.00 499,250.00 0.560 1,826 686 0.590 11/17/2025 3135GA7D7 1299 Federal National Mtg Assn 12/23/2020 500,000.00 462,955.00 500,000.00 0.600 1,826 722 0.600 12/23/2025 3135GAAW1 1300 Federal National Mtg Assn 12/30/2020 500,000.00 478,505.00 500,000.00 0.400 1,461 364 0.400 12/30/2024 3135GO6G3 1354 Federal National Mtg Assn 12/07/2021 1,000,000.00 931,660.00 976,300.00 0.500 1,431 676 1.120 11/07/2025 3135GO3U5 1365 Federal National Mtg Assn 01/28/2022 500,000.00 475,465.00 487,790.00 0.625 1,180 477 1.400 04/22/2025 3135GAGA3 1480 Federal National Mtg Assn 04/03/2023 2,000,000.00 1,996,460.00 2,000,000.00 5.200 484 211 5.206 07/30/2024 3135GAGK1 1482 Federal National Mtg Assn 04/12/2023 3,000,000.00 2,996,700.00 3,000,000.00 5.050 366 102 5.050 04/12/2024 Subtotal and Average 50,853,035.09 52,000,000.00 50,037,016.00 51,755,823.74 1,524 798 2.358 Federal Agency Discount 313384YJ2 1534 Federal Home Loan Bank 09/07/2023 2,000,000.00 1,951,080.00 1,916,929.44 5.210 287 171 5.533 06/20/2024 Subtotal and Average 1,916,929.44 2,000,000.00 1,951,080.00 1,916,929.44 287 171 5.533 Treasury Coupon Securities 912828YV6 1241 U.S. Treasury 12/16/2019 1,000,000.00 969,920.00 989,687.50 1.500 1,811 334 1.718 11/30/2024 91282CBC4 1303 U.S. Treasury 01/07/2021 500,000.00 463,495.00 498,632.81 0.375 1,819 730 0.431 12/31/2025 91282CBH3 1309 U.S. Treasury 02/23/2021 500,000.00 462,050.00 495,100.00 0.375 1,803 761 0.577 01/31/2026 91282CAT8 1311 U.S. Treasury 03/30/2021 1,000,000.00 929,100.00 977,500.00 0.250 1,676 669 0.750 10/31/2025 91282CAZ4 1315 U.S. Treasury 04/22/2021 500,000.00 464,455.00 492,187.50 0.375 1,683 699 0.720 11/30/2025 91282CB03 1319 U.S. Treasury 05/28/2021 500,000.00 462,205.00 494,165.00 0.500 1,737 789 0.750 02/28/2026 91282CBT7 1320 U.S. Treasury 05/28/2021 500,000.00 464,045.00 499,525.00 0.750 1,768 820 0.770 03/31/2026 91282CCF6 1321 U.S. Treasury 06/01/2021 1,000,000.00 923,440.00 997,060.00 0.750 1,825 881 0.810 05/31/2026 91282CBT7 1322 U.S. Treasury 06/17/2021 500,000.00 464,045.00 498,450.00 0.750 1,748 820 0.816 03/31/2026 91282CCF6 1323 U.S. Treasury 06/17/2021 500,000.00 461,720.00 497,095.00 0.750 1,809 881 0.870 05/31/2026 91282CCP4 1335 U.S. Treasury 09/29/2021 1,000,000.00 916,290.00 983,750.00 0.625 1,766 942 0.970 07/31/2026 91282CCW9 1336 U.S. Treasury 09/29/2021 1,000,000.00 917,230.00 988,500.00 0.750 1,797 973 0.990 08/31/2026 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 4 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Treasury Coupon Securities 91282CBEO 1342 U.S. Treasury 10/22/2021 1,000,000.00 998,160.00 991,000.00 0.125 815 14 0.531 01/15/2024 91282CDB4 1343 U.S. Treasury 10/22/2021 1,000,000.00 967,190.00 996,320.00 0.625 1,089 288 0.750 10/15/2024 91282CBR1 1352 U.S. Treasury 12/07/2021 1,000,000.00 990,040.00 989,800.00 0.250 829 74 0.704 03/15/2024 91282CBV2 1360 U.S. Treasury 01/05/2022 500,000.00 493,125.00 494,882.81 0.375 831 105 0.830 04/15/2024 912828Z78 1369 U.S. Treasury 02/10/2022 1,000,000.00 928,710.00 986,700.00 1.500 1,816 1,126 1.781 01/31/2027 91282CCW9 1380 U.S. Treasury 03/22/2022 500,000.00 458,615.00 466,454.17 0.750 1,623 973 2.350 08/31/2026 91282CDG3 1381 U.S. Treasury 03/22/2022 500,000.00 461,620.00 473,396.82 1.125 1,684 1,034 2.350 10/31/2026 91282CBQ3 1382 U.S. Treasury 03/23/2022 750,000.00 693,307.50 698,025.00 0.500 1,438 789 2.353 02/28/2026 9128286S4 1383 U.S. Treasury 03/23/2022 1,000,000.00 961,370.00 999,010.00 2.375 1,499 850 2.400 04/30/2026 9128283DO 1390 U.S. Treasury 05/03/2022 1,000,000.00 978,440.00 985,190.00 2.250 912 304 2.870 10/31/2024 91282CEF4 1391 U.S. Treasury 05/03/2022 1,000,000.00 956,330.00 976,860.00 2.500 1,793 1,185 3.010 03/31/2027 912828X88 1397 U.S. Treasury 06/07/2022 1,000,000.00 950,390.00 969,687.50 2.375 1,803 1,230 3.041 05/15/2027 91282CEN7 1398 U.S. Treasury 06/08/2022 500,000.00 481,250.00 495,000.00 2.750 1,787 1,215 2.971 04/30/2027 91282CET4 1399 U.S. Treasury 06/08/2022 500,000.00 478,865.00 491,842.18 2.625 1,818 1,246 2.980 05/31/2027 9128282U3 1400 U.S. Treasury 06/09/2022 500,000.00 489,765.00 490,850.00 1.875 814 243 2.727 08/31/2024 91282CF62 1417 U.S. Treasury 08/15/2022 1,000,000.00 960,550.00 989,460.00 2.750 1,811 1,307 2.980 07/31/2027 912828XT2 1418 U.S. Treasury 05/04/2022 1,000,000.00 986,680.00 985,240.00 2.000 758 151 2.736 05/31/2024 91282CFB2 1422 U.S. Treasury 08/29/2022 1,000,000.00 960,550.00 979,645.67 2.750 1,797 1,307 3.200 07/31/2027 912828280 1439 U.S. Treasury 11/18/2022 1,000,000.00 943,790.00 927,110.00 2.250 1,731 1,322 3.950 08/15/2027 91282CFH9 1456 U.S. Treasury 01/24/2023 500,000.00 486,270.00 489,175.00 3.125 1,680 1,338 3.640 08/31/2027 91282CGH8 1460 U.S. Treasury 02/02/2023 1,000,000.00 985,000.00 996,369.14 3.500 1,824 1,491 3.580 01/31/2028 91282CEW7 1465 U.S. Treasury 02/15/2023 1,000,000.00 977,850.00 967,220.00 3.250 1,596 1,276 4.075 06/30/2027 91282CGT2 1508 U.S. Treasury 06/15/2023 1,000,000.00 989,920.00 984,600.00 3.625 1,751 1,551 3.980 03/31/2028 912828V80 1516 U.S. Treasury 06/30/2023 2,000,000.00 1,995,020.00 1,964,400.00 2.250 215 30 5.374 01/31/2024 91282BB66 1518 U.S. Treasury 07/12/2023 2,000,000.00 1,993,700.00 1,969,580.00 2.750 218 45 5.382 02/15/2024 91282CDVO 1519 U.S. Treasury 07/12/2023 1,000,000.00 996,460.00 975,600.00 0.875 203 30 5.416 01/31/2024 91282CGT2 1524 U.S. Treasury 05/31/2023 1,000,000.00 989,920.00 990,000.00 3.625 1,766 1,551 3.853 03/31/2028 91282CHA2 1525 U.S. Treasury 05/31/2023 1,000,000.00 984,960.00 985,000.00 3.500 1,796 1,581 3.837 04/30/2028 91282CEK3 1528 U.S. Treasury 08/10/2023 1,000,000.00 990,860.00 980,080.00 2.500 264 120 5.340 04/30/2024 912828W71 1530 U.S. Treasury 08/10/2023 2,000,000.00 1,984,060.00 1,960,078.13 2.125 234 90 5.338 03/31/2024 9128282U3 1535 U.S. Treasury 09/07/2023 3,000,000.00 2,938,590.00 2,899,170.81 1.875 359 243 5.440 08/31/2024 9128282N9 1536 U.S. Treasury 09/07/2023 2,000,000.00 1,966,260.00 1,942,840.00 2.125 328 212 5.431 07/31/2024 91282CGT2 1543 U.S. Treasury 10/19/2023 1,000,000.00 989,920.00 949,180.00 3.625 1,625 1,551 4.910 03/31/2028 91282CFUO 1550 U.S. Treasury 11/06/2023 750,000.00 755,272.50 739,200.00 4.125 1,455 1,399 4.524 10/31/2027 9128285MB 1565 U.S. Treasury 12/29/2023 1,000,000.00 966,990.00 966,718.75 3.125 1,783 1,780 3.880 11/15/2028 Subtotal and Average 44,131,270.24 45,500,000.00 44,027,795.00 44,557,338.79 1,202 720 3.242 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 5 CUSIP Average Investment # Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate Days to Term Maturity YTM Maturity 365 Date Treasury Discount Notes 912796CX5 1542 U.S. Treasury 10/18/2023 2,000,000.00 1,969,140.00 1,945,964.16 5.315 183 108 5.615 04/18/2024 912797HH3 1551 U.S. Treasury 11/06/2023 1,000,000.00 982,670.00 974,178.00 5.222 178 122 5.511 05/02/2024 912797HS9 1558 U.S. Treasury 12/04/2023 2,000,000.00 1,958,220.00 1,949,466.22 5.110 178 150 5.389 05/30/2024 Subtotal and Average 7,225,015.19 5,000,000.00 4,910,030.00 4,869,608.38 180 128 5.504 Certificate of Deposits 336460CX6 1222 First State Bk DeQueen 08/30/2019 248,000.00 242,357.64 248,000.00 1.800 1,827 242 1.802 08/30/2024 31911KAK4 1515 First Bank Elk River 06/30/2023 248,000.00 244,793.52 248,000.00 4.400 1,827 1,642 4.405 06/30/2028 32027BALl 1273 First Freedom Bank 04/29/2020 249,000.00 236,201.79 249,000.00 1.200 1,826 484 1.201 04/29/2025 33766LAJ7 1216 FirsTier Bank 08/23/2019 249,000.00 243,533.23 249,000.00 1.950 1,827 235 1.952 08/23/2024 32056GDJ6 1278 list Internet Bank 05/11/2020 248,000.00 234,284.04 248,000.00 1.000 1,827 497 0.985 05/12/2025 32112UDR9 1274 First Nall Bk McGregor 04/28/2020 248,000.00 235,760.29 248,000.00 1.350 1,826 483 1.351 04/28/2025 334342CD2 1221 First Natl Bk of Syracuse 08/30/2019 249,000.00 243,417.96 249,000.00 1.850 1,827 242 1.852 08/30/2024 32114VBT3 1250 First National Bank Michigan 02/14/2020 248,000.00 237,340.44 248,000.00 1.650 1,827 410 1.652 02/14/2025 33625CCP2 1209 First Security Bank of WA 07/30/2019 248,000.00 243,260.00 248,000.00 2.000 1,827 211 2.002 07/30/2024 33640VDD7 1231 First Service Bank 11/15/2019 248,000.00 244,581.52 248,000.00 1.700 1,643 135 1.701 05/15/2024 88413QDN5 1420 Third Federal Savings and Loan 08/19/2022 245,000.00 232,568.14 245,000.00 3.300 1,826 1,326 3.302 08/19/2027 00257TBD7 1207 Abacus Federal Savings 07/26/2019 248,000.00 243,097.48 248,000.00 1.950 1,827 207 1.952 07/26/2024 00435J131-15 1256 Access Bank 03/13/2020 248,000.00 237,380.51 248,000.00 1.600 1,826 437 1.601 03/13/2025 00833JAQ4 1478 Affinity Bank 03/17/2023 248,000.00 243,827.88 248,000.00 4.900 1,827 1,537 4.906 03/17/2028 01025RAG4 1510 Alabama Credit Union 06/20/2023 248,000.00 246,895.30 248,000.00 5.000 1,098 903 5.005 06/22/2026 011852AEO 1469 Alaska USA/Global FCU 03/08/2023 248,000.00 240,990.63 248,000.00 4.600 1,827 1,528 4.606 03/08/2028 01882MAC6 1451 Alliant CU 12/30/2022 247,000.00 248,588.75 247,000.00 5.000 1,826 1,459 5.003 12/30/2027 01664MAB2 1448 All In FCU 12/20/2022 248,000.00 244,214.33 248,000.00 4.400 1,826 1,449 4.402 12/20/2027 02007GPX5 1388 Ally Bank Midvale 04/21/2022 245,000.00 236,825.80 245,000.00 2.550 1,096 476 2.550 04/21/2025 020080BX4 1267 Alma Bank 03/30/2020 248,000.00 236,518.01 248,000.00 1.400 1,824 452 1.399 03/28/2025 029728BC5 1255 American State 02/21/2020 248,000.00 237,851.42 248,000.00 1.600 1,827 417 1.602 02/21/2025 02589ADH2 1421 American Express, NB 08/29/2022 245,000.00 233,661.65 245,000.00 3.450 1,793 1,303 3.067 07/27/2027 023570AQO 1372 Amerant Bank 02/14/2022 245,000.00 221,662.83 245,000.00 1.600 1,828 1,142 1.601 02/16/2027 052392BT3 1427 Austin Telco FCU 09/21/2022 248,000.00 239,137.10 248,000.00 3.800 1,826 1,359 3.770 09/21/2027 05465DAE8 1258 Axos Bank 03/26/2020 248,000.00 237,317.21 248,000.00 1.650 1,826 450 1.651 03/26/2025 05765LBUO 1520 Balboa Thrift and Loan 07/19/2023 248,000.00 246,914.48 248,000.00 4.400 1,827 1,661 4.405 07/19/2028 062119BTB 1492 Bank Five Nine 05/12/2023 248,000.00 237,409.75 248,000.00 4.250 1,827 1,593 4.255 05/12/2028 06610RCA5 1499 Bankers Bank 05/24/2023 248,000.00 236,367.49 248,000.00 4.150 1,827 1,605 4.155 05/24/2028 07371AYE7 1370 Beal Bank TX 02/23/2022 245,000.00 224,011.49 245,000.00 1.900 1,820 1,143 1.901 02/17/2027 073710E88 1371 Beal Bank USA 02/23/2022 245,000.00 223,770.37 245,000.00 1.900 1,820 1,143 1.901 02/17/2027 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 6 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate Days to Term Maturity YTM Maturity 365 Date Certificate of Deposits 08016PDQ9 1270 Belmont Bank and Trust 04/16/2020 248,000.00 244,974.34 248,000.00 1.250 1,461 106 1.251 04/16/2024 06417NZQ9 1329 Bank OZK 07/29/2021 248,000.00 234,832.93 248,000.00 0.400 1,280 394 0.401 01/29/2025 064520BG3 1287 Bank Princeton 06/30/2020 248,000.00 236,153.43 248,000.00 0.500 1,644 364 0.500 12/30/2024 064860MCO 1476 Bank of the Sierra 03/15/2023 244,000.00 239,728.55 244,000.00 4.600 1,461 1,169 4.604 03/15/2027 09582YAF9 1467 Blue Ridge Bank 02/28/2023 244,000.00 233,469.99 244,000.00 4.200 1,826 1,519 4.202 02/28/2028 05580AD50 1333 BMW Bank 09/10/2021 245,000.00 237,175.02 245,000.00 0.650 1,096 253 0.651 09/10/2024 06652CHBO 1227 BankWest Inc 09/27/2019 248,000.00 241,427.17 248,000.00 1.700 1,827 270 1.702 09/27/2024 05584CJJ6 1533 BNY Mellon 09/07/2023 244,000.00 244,370.24 244,000.00 4.500 1,827 1,711 4.505 09/07/2028 108622NJ6 1479 Bridgewater Bank 03/29/2023 248,000.00 245,463.69 248,000.00 4.850 1,461 1,183 4.767 03/29/2027 13016261-3 1564 California Credit Union 12/28/2023 244,000.00 244,274.48 244,000.00 5.100 550 546 5.105 06/30/2025 14042RQBO 1346 Capital One Nail Assn FDIC4297 11/17/2021 248,000.00 222,727.20 248,000.00 1.100 1,826 1,051 1.101 11/17/2026 14042TDD6 1271 Capital One USA FDIC33954 04/08/2020 245,000.00 234,104.54 245,000.00 1.600 1,826 463 1.601 04/08/2025 14622LAAO 1316 Carter FCU 04/27/2021 248,000.00 226,548.39 248,000.00 0.750 1,826 847 0.750 04/27/2026 20033A3A2 1386 Comenity Capital Bank 04/14/2022 248,000.00 231,104.79 248,000.00 2.650 1,826 1,199 2.652 04/14/2027 15118RRH2 1220 Celtic Bank 08/30/2019 248,000.00 242,440.37 248,000.00 1.850 1,827 242 1.852 08/30/2024 156634AK3 1184 Century Next Bank 05/29/2019 248,000.00 245,035.25 248,000.00 2.500 1,827 149 2.503 05/29/2024 152577BN1 1493 Central Bank 05/12/2023 248,000.00 234,975.04 248,000.00 4.000 1,827 1,593 4.005 05/12/2028 169894AS1 1284 Chippewa Valley Bk 06/24/2020 248,000.00 232,496.36 248,000.00 0.600 1,826 540 0.600 06/24/2025 16141BAC5 1506 Charlway FCU 06/09/2023 248,000.00 246,237.38 248,000.00 4.900 1,096 890 4.905 06/09/2026 12547CBJ6 1497 CIBC Bank USA 05/16/2023 244,000.00 234,535.13 244,000.00 4.350 1,827 1,597 4.355 05/16/2028 17286TAGO 1252 Citadel FCU 02/27/2020 248,000.00 237,875.70 248,000.00 1.650 1,827 423 1.652 02/27/2025 2027506M2 1268 Commonwealth Business Bk 03/31/2020 248,000.00 235,995.58 248,000.00 1.250 1,826 455 1.251 03/31/2025 20825WAR1 1357 Connexus CU 12/23/2021 249,000.00 223,623.50 249,000.00 1.250 1,826 1,087 1.250 12/23/2026 22258JA67 1430 County Schools FCU 09/30/2022 248,000.00 240,314.64 248,000.00 4.400 1,826 1,368 4.325 09/30/2027 20416TAQ5 1202 Communitywide FCU 06/28/2019 248,000.00 244,149.36 248,000.00 2.250 1,827 179 2.253 06/28/2024 20786ADL6 1334 Connect One 09/24/2021 248,000.00 221,914.91 248,000.00 0.800 1,826 997 0.800 09/24/2026 176688CP2 1199 Citizens State Bank 06/21/2019 248,000.00 244,473.02 248,000.00 2.400 1,827 172 2.403 06/21/2024 23204HPB8 1507 Customers Bank 06/14/2023 244,000.00 242,053.80 244,000.00 4.500 1,827 1,626 4.505 06/14/2028 23248UAB3 1494 Cy -Fair FCU 05/12/2023 248,000.00 239,844.46 248,000.00 4.500 1,827 1,593 4.505 05/12/2028 24773RCR4 1377 Delta Nall B&T 03/09/2022 245,000.00 224,336.22 245,000.00 2.000 1,814 1,151 2.001 02/25/2027 25460FDW3 1438 Direct FCU 11/07/2022 248,000.00 247,739.57 248,000.00 4.800 1,827 1,407 4.735 11/08/2027 254673E69 1392 Discover Bank Greenwood DE CF 05/24/2022 245,000.00 238,284.99 245,000.00 3.100 1,099 512 3.103 05/27/2025 25844MAK4 1447 Dort Financial CU 12/16/2022 247,000.00 244,121.28 247,000.00 4.500 1,826 1,445 4.503 12/16/2027 27004PCM3 1375 Eaglemark Savings 03/02/2022 245,000.00 224,249.36 245,000.00 2.000 1,826 1,156 2.001 03/02/2027 291916AJ3 1555 Empower FCU 11/15/2023 247,000.00 249,721.34 247,000.00 5.250 1,827 1,780 5.255 11/15/2028 299547AQ2 1196 Liberty FCU F/K/A Evansville T 06/12/2019 248,000.00 244,877.29 248,000.00 2.600 1,827 163 2.603 06/12/2024 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 7 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate Days to Term Maturity YTM Maturity 365 Date Certificate of Deposits 87270LDL4 1306 TIAA F/K/A EverBank 02/12/2021 245,000.00 223,602.97 245,000.00 0.500 1,826 773 0.500 02/12/2026 300185LM5 1457 Evergreen Bank Group 01/27/2023 248,000.00 241,854.89 248,000.00 3.850 1,277 938 3.849 07/27/2026 307811DF3 1363 Farmers & Merch 01/14/2022 249,000.00 233,528.25 249,000.00 0.900 1,277 560 0.900 07/14/2025 30960QAR8 1526 Farmers Insurance Group FCU 07/26/2023 248,000.00 248,154.97 248,000.00 5.400 733 574 5.408 07/28/2025 31617CAV5 1317 Fidelity Homestead 04/30/2021 248,000.00 225,081.63 248,000.00 0.700 1,826 850 0.711 04/30/2026 33847E3A3 1276 Flagstar 04/30/2020 248,000.00 235,443.90 248,000.00 1.250 1,826 485 1.251 04/30/2025 34520LATO 1435 Forbright Bank 11/02/2022 248,000.00 245,955.75 248,000.00 4.600 1,826 1,401 4.602 11/02/2027 319137CB9 1562 First Bank 12/28/2023 244,000.00 243,388.29 244,000.00 4.450 729 725 4.456 12/26/2025 35637RDC8 1248 Freedom Financial 02/14/2020 248,000.00 237,817.29 248,000.00 1.550 1,827 410 1.552 02/14/2025 35089LAFO 1491 Four Points FCU 05/10/2023 248,000.00 244,255.51 248,000.00 4.550 1,097 861 4.443 05/11/2026 372348DJ8 1556 The Genoa Banking Company 11/28/2023 248,000.00 244,824.06 248,000.00 4.600 1,827 1,793 4.605 11/28/2028 37173RAL7 1561 Genesee Regional Bank 12/27/2023 244,000.00 242,829.86 244,000.00 4.200 1,097 1,092 3.638 12/28/2026 38149MXK4 1326 Goldman Sachs 07/28/2021 248,000.00 224,336.93 248,000.00 1.000 1,826 939 1.001 07/28/2026 38120MCA2 1511 Golden State Business Bank 06/22/2023 249,000.00 242,682.58 249,000.00 4.450 1,461 1,268 4.453 06/22/2027 39573LBC1 1313 Greenstate FCU 04/16/2021 249,000.00 227,728.72 249,000.00 0.950 1,826 836 0.951 04/16/2026 397417AQ9 1419 Greenwoods State Bank 05/17/2022 248,000.00 233,839.82 248,000.00 3.050 1,826 1,232 3.052 05/17/2027 42228LAN1 1547 Healthcare Systems FCU 10/27/2023 248,000.00 245,623.50 248,000.00 5.100 1,827 1,761 5.106 10/27/2028 45157PAZ3 1450 Ideal CU 12/29/2022 248,000.00 245,061.30 248,000.00 4.500 1,826 1,458 4.502 12/29/2027 46256YAZ2 1186 Iowa State Bank 05/23/2019 245,000.00 242,128.24 245,000.00 2.400 1,827 143 2.403 05/23/2024 472312AA5 1514 Jeep Country FCU 06/29/2023 248,000.00 243,625.16 248,000.00 4.700 1,461 1,275 4.704 06/29/2027 48128HXU7 1185 JP Morgan Chase 05/16/2019 245,000.00 243,047.06 245,000.00 3.250 1,827 136 3.254 05/16/2024 49306SJ56 1475 Kay Bank, N.A. 03/15/2023 244,000.00 242,644.57 244,000.00 5.000 733 441 5.008 03/17/2025 499724AP7 1532 Knoxville TVA Credit Union 08/25/2023 248,000.00 243,057.90 248,000.00 4.850 1,827 1,698 4.854 08/25/2028 51828MAC8 1449 Latino Comm. CU 12/21/2022 248,000.00 245,109.85 248,000.00 4.500 1,826 1,450 4.503 12/21/2027 530520AH8 1466 Liberty First CU 02/21/2023 248,000.00 240,101.16 248,000.00 4.500 1,827 1,513 4.504 02/22/2028 501798RP9 1356 LCA Bank Corp 12/27/2021 248,000.00 225,580.01 248,000.00 1.000 1,642 907 1.000 06/26/2026 52168UHY1 1389 Leader Bank 04/22/2022 245,000.00 236,813.75 245,000.00 2.550 1,096 477 2.552 04/22/2025 52171MAM7 1549 Leaders Credit Union 10/30/2023 248,000.00 249,782.90 248,000.00 5.100 1,827 1,764 5.106 10/30/2028 52470QEC4 1539 Legacy Bank & Trust 09/27/2023 248,000.00 239,359.38 248,000.00 4.500 1,827 1,731 4.505 09/27/2028 524661CB9 1197 Legacy Bank 06/19/2019 248,000.00 244,512.69 248,000.00 2.400 1,827 170 2.403 06/19/2024 50625LAW3 1384 Lafayette FCU 03/30/2022 248,000.00 245,978.16 248,000.00 2.050 729 87 2.053 03/28/2024 538036GVO 1238 Live Oak Bank 11/27/2019 248,000.00 244,366.54 248,000.00 1.800 1,644 148 1.802 05/28/2024 51210SQU4 1208 Lakeside Bank 07/30/2019 248,000.00 247,277.27 248,000.00 2.000 1,644 28 2.003 01/29/2024 51507LCC6 1305 Landmark Community Bank 01/22/2021 248,000.00 226,745.58 248,000.00 0.500 1,826 752 0.500 01/22/2026 560507AQ8 1522 Maine Savings FCU 07/21/2023 248,000.00 242,626.84 248,000.00 4.800 1,827 1,663 4.806 07/21/2028 56065GAG3 1188 Main Street Bank 04/26/2019 248,000.00 245,794.29 248,000.00 2.600 1,827 116 2.603 04/26/2024 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 8 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate Days to Term Maturity YTM Maturity 365 Date Certificate of Deposits 58404DTP6 1545 Medallion Bank 10/20/2023 248,000.00 248,371.67 248,000.00 4.850 1,827 1,754 4.855 10/20/2028 59161YAP1 1373 Metro Credit Union 02/18/2022 249,000.00 225,736.65 249,000.00 1.700 1,826 1,144 1.701 02/18/2027 59524LAA4 1474 Mid Carolina Credit Union 03/13/2023 248,000.00 246,704.47 248,000.00 4.850 1,096 802 4.855 03/13/2026 60425SKB4 1486 Minnwest Bank 05/01/2023 248,000.00 240,578.75 248,000.00 4.250 1,463 1,218 4.254 05/03/2027 60936TAL3 1538 Money One FCU 09/14/2023 248,000.00 244,600.03 248,000.00 5.000 1,827 1,718 5.005 09/14/2028 61690UNX4 1237 Morgan Stanley Bank 11/20/2019 245,000.00 237,403.81 245,000.00 1.950 1,827 324 1.952 11/20/2024 59013KPNO 1345 Merrick Bank 11/09/2021 249,000.00 223,612.81 249,000.00 1.100 1,826 1,043 1.101 11/09/2026 565819AG4 1379 Marathon Bnak 03/16/2022 248,000.00 225,121.90 248,000.00 1.800 1,826 1,170 1.801 03/16/2027 61760A3133 1236 Morgan Stanley Private Bk, NA 11/20/2019 245,000.00 237,296.87 245,000.00 1.900 1,827 324 1.902 11/20/2024 62384RAT3 1485 Mountain America Federal CU 04/28/2023 248,000.00 247,188.14 248,000.00 4.700 1,096 848 4.705 04/28/2026 654062JZ2 1266 Nicolet Nall Bank 03/31/2020 248,000.00 236,447.53 248,000.00 1.400 1,826 455 1.401 03/31/2025 64034KAZ4 1376 Nelnet Bank 03/02/2022 245,000.00 229,629.56 245,000.00 1.800 1,461 791 1.801 03/02/2026 666613MK7 1544 Northpointe Bank 10/20/2023 248,000.00 246,623.83 248,000.00 4.850 1,827 1,754 4.855 10/20/2028 66736ABP3 1181 Northwest Bank 02/13/2019 248,000.00 247,227.05 248,000.00 2.950 1,826 43 2.951 02/13/2024 67886WAJ6 1559 Oklahoma Credit Union 12/14/2023 248,000.00 248,374.97 248,000.00 5.700 183 165 5.716 06/14/2024 69506YRH4 1269 Pacific Western Bk/Banc of CA 04/16/2020 245,000.00 242,054.84 245,000.00 1.300 1,461 106 1.301 04/16/2024 70962LAF9 1331 Pentagon FCU 09/01/2021 249,000.00 231,724.74 249,000.00 0.700 1,462 610 0.687 09/02/2025 710571DS6 1210 People's Bank 07/31/2019 248,000.00 243,238.09 248,000.00 2.000 1,827 212 2.002 07/31/2024 724468AC7 1483 Pitney Bowes Bank 04/14/2023 244,000.00 234,725.85 244,000.00 4.350 1,826 1,564 4.355 04/13/2028 72651LCL6 1195 Plains Commerce Bank 06/07/2019 245,000.00 241,973.65 245,000.00 2.550 1,827 158 2.553 06/07/2024 732329BDB 1425 Ponce Bank 09/15/2022 248,000.00 236,624.10 248,000.00 3.500 1,826 1,353 3.502 09/15/2027 740367HP5 1213 Preferred Bank 08/16/2019 249,000.00 243,769.31 249,000.00 2.000 1,827 228 2.002 08/16/2024 761402BY1 1203 Revere Bank 06/28/2019 247,000.00 243,267.33 247,000.00 2.300 1,827 179 2.303 06/28/2024 77579ADFO 1251 Rollstone B&T 02/12/2020 245,000.00 243,848.80 245,000.00 1.650 1,461 42 1.651 02/12/2024 77357DADO 1560 Rockland Federal Credit Union 12/22/2023 248,000.00 248,000.00 248,000.00 4.600 1,096 1,086 4.604 12/22/2026 795451AFO 1327 Sallie Mae Bank Salt Lake City 07/28/2021 248,000.00 224,749.72 248,000.00 1.000 1,826 939 1.001 07/28/2026 804375DL4 1235 Sauk Valley B&T Co 11/07/2019 248,000.00 240,018.62 248,000.00 1.700 1,827 311 1.702 11/07/2024 843383CS7 1498 Southern Bank Poplar MO 05/17/2023 248,000.00 236,906.45 248,000.00 4.200 1,827 1,598 4.205 05/17/2028 80865MAB3 1454 Scient FCU 01/13/2023 248,000.00 246,398.33 248,000.00 4.650 731 378 4.656 01/13/2025 79772FAG1 1459 San Francisco FCU 02/03/2023 248,000.00 243,469.72 248,000.00 4.350 1,826 1,494 4.352 02/03/2028 82671DAB3 1458 Signature FCU 01/31/2023 248,000.00 243,949.14 248,000.00 4.400 1,826 1,491 4.402 01/31/2028 78472EABO 1455 SPCO Credit Union 01/20/2023 249,000.00 239,879.01 249,000.00 4.350 1,826 1,480 4.352 01/20/2028 849430BF9 1257 Spring Bank 03/20/2020 248,000.00 236,980.64 248,000.00 1.500 1,826 444 1.501 03/20/2025 84229LBA9 1434 Southern Bank Sardis GA 10/28/2022 244,000.00 241,165.68 244,000.00 4.250 1,188 758 4.254 01/28/2026 84223QAN7 1286 Southern Bancorp Bk 06/26/2020 248,000.00 238,463.50 248,000.00 0.500 1,582 298 0.500 10/25/2024 85279AAC6 1509 St Vincent Med Center FCU 06/16/2023 248,000.00 242,953.91 248,000.00 4.600 1,461 1,262 4.604 06/16/2027 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Portfolio Details - Investments December 31, 2023 Page 9 CUSIP Average Investment # Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate Days to Term Maturity YTM Maturity 365 Date Certificate of Deposits 87165ET98 1332 Synchrony Bank Retail 09/03/2021 245,000.00 220,903.21 245,000.00 0.900 1,826 976 0.900 09/03/2026 89388CEYO 1328 Transportation Alliance Bk TAB 07/23/2021 248,000.00 235,284.87 248,000.00 0.400 1,280 388 0.401 01/23/2025 87868YA06 1501 Technology Credit Union 05/30/2023 248,000.00 246,829.31 248,000.00 5.000 1,095 879 5.005 05/29/2026 882213AB7 1260 Texas Bank Financial 03/31/2020 245,000.00 242,428.14 245,000.00 1.100 1,458 87 1.101 03/28/2024 472382AQ3 1272 The Jefferson Bank 04/15/2020 248,000.00 245,001.86 248,000.00 1.250 1,461 105 1.251 04/15/2024 89235MKY6 1314 Toyota Financial Savings Bank 04/22/2021 245,000.00 223,830.56 245,000.00 0.900 1,826 842 0.900 04/22/2026 89269FDP7 1415 Tradition Capital 07/20/2022 246,000.00 245,596.05 246,000.00 3.000 551 21 3.008 01/22/2024 89789AAG2 1473 Truliant FCU 03/10/2023 248,000.00 242,986.87 248,000.00 4.700 1,645 1,348 4.707 09/10/2027 89841MAX5 1563 Trustone Financial CU 12/28/2023 248,000.00 246,507.72 248,000.00 5.150 365 361 5.164 12/27/2024 89786MAF1 1368 True Sky FCU 02/04/2022 245,000.00 221,895.72 245,000.00 1.600 1,826 1,130 1.601 02/04/2027 898812AC6 1537 Tucson FCU 09/08/2023 248,000.00 251,224.00 248,000.00 5.000 1,827 1,712 5.005 09/08/2028 90355GHG4 1546 UBS Bank USA 10/25/2023 248,000.00 243,498.68 248,000.00 4.900 1,827 1,759 4.905 10/25/2028 909557KQ2 1477 United Bankers Bank 03/16/2023 248,000.00 246,604.08 248,000.00 5.000 732 441 4.823 03/17/2025 914098DJ4 1442 University Bank 11/30/2022 249,000.00 243,845.97 249,000.00 4.200 1,826 1,429 4.202 11/30/2027 914242AAO 1429 University Credit Union 09/26/2022 248,000.00 244,119.56 248,000.00 4.000 1,096 634 3.891 09/26/2025 91527PBY2 1495 Univest Bank & Trust 05/12/2023 248,000.00 238,383.64 248,000.00 4.350 1,827 1,593 4.355 05/12/2028 90983WBT7 1249 United Community 02/07/2020 248,000.00 238,249.47 248,000.00 1.650 1,827 403 1.652 02/07/2025 910286GN7 1513 United Fidelity Bank 06/29/2023 248,000.00 245,713.34 248,000.00 4.500 1,827 1,641 4.505 06/29/2028 91139LAB2 1378 United Roosevelt Savings 03/11/2022 248,000.00 226,037.12 248,000.00 1.900 1,826 1,165 1.901 03/11/2027 90352RDB8 1500 US Alliance FCU 05/26/2023 248,000.00 240,282.15 248,000.00 4.550 1,827 1,607 4.555 05/26/2028 91739JAB1 1523 Utah First FCU 07/21/2023 245,000.00 241,687.84 245,000.00 5.000 1,827 1,663 5.006 07/21/2028 913065ADO 1553 United Teletech Financial FCU 11/08/2023 248,000.00 245,976.53 248,000.00 5.100 1,461 1,407 5.103 11/08/2027 92559TAJ7 1325 Vibrant Credit Union 07/02/2021 249,000.00 222,962.30 248,377.50 0.800 1,824 911 0.852 06/30/2026 92834ABT2 1496 VisionBank 05/12/2023 248,000.00 242,873.64 248,000.00 4.050 1,827 1,593 4.055 05/12/2028 92023CAJ2 1552 ValleyStar Credit Union 11/08/2023 247,000.00 250,333.71 247,000.00 5.200 1,827 1,773 5.205 11/08/2028 92891CCZ3 1472 VystarCU 03/10/2023 248,000.00 240,522.69 248,000.00 4.550 1,827 1,530 4.555 03/10/2028 949763XY7 1174 Wells Fargo 02/27/2019 248,000.00 247,014.48 248,000.00 3.000 1,826 57 3.001 02/27/2024 98138MCA6 1548 Workers FCU 10/30/2023 248,000.00 246,677.28 248,000.00 5.200 1,827 1,764 5.206 10/30/2028 938828131-12 1215 Washington Federal 08/23/2019 248,000.00 242,635.56 248,000.00 2.000 1,827 235 2.002 08/23/2024 95960NKD8 1277 Western State Bank 05/13/2020 245,000.00 230,420.43 245,000.00 1.000 1,826 498 1.001 05/13/2025 Subtotal and Average 40,833,764.60 41,546,000.00 40,174,158.18 41,545,377.50 1,642 891 2.999 Corporate Notes 45950VPS9 1308 International Finance Corp. 02/26/2021 500,000.00 459,460.00 497,300.00 0.500 1,826 787 0.610 02/26/2026 931142EE9 1512 Wal-Mart Stores, Inc 06/26/2023 1,000,000.00 988,840.00 973,110.00 3.700 1,827 1,638 4.303 06/26/2028 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0 City of La Quinta Portfolio Management Page 10 Portfolio Details - Investments December 31, 2023 Average Purchase Stated Days to YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Maturity 365 Date Subtotal and Average 1,470,410.00 1,500,000.00 1,448,300.00 1,470,410.00 1,827 1,350 3.054 Money Market with Fiscal Agent SYS1058 1058 US Bank 07/01/2016 13,958.98 13,958.98 13,958.98 1 1 0.000 Subtotal and Average 13,905.66 13,958.98 13,958.98 13,958.98 1 1 0.000 CERBT - OPEB Trust SYS1114 1114 CAPERS CERBT Plan 07/01/2023 1,955,099.21 1,955,099.21 1,955,099.21 1 1 0.000 Subtotal and Average 1,779,216.02 1,955,099.21 1,955,099.21 1,955,099.21 1 1 0.000 PARS Pension Trust SYS1230 1230 Pblc Agncy Rtrmnt Sery 5,544,348.61 5,544,348.61 5,544,348.61 1 1 0.000 Subtotal and Average 5,326,469.09 5,544,348.61 5,544,348.61 5,544,348.61 1 1 0.000 Total and Average 229,230,087.47 229,846,760.91 224,301,222.07 228,416,248.76 920 505 3.407 Portfolio CITY CP Run Date: 02/01/2024 - 18:22 PM (PRF_PM2) 7.3.0